The DeanBeat: What happens to a game's story when it gets stretched too long?

Some games go on so long that the strong narrative turns into a dramatic fizzle.